Bayani Bulb Bases Dashboard

Summary Report

The dashboard provides insights into Bayani Bulb Bases' operational efficiency across its factories in Appleton WI, Greenville SC, and Henderson NV. The charts visualize monthly average production times, temporary storage times, shipping times, cases produced, and cases shipped, filtered by factory, product, year, and warehouse.

Interesting Fact: Henderson NV consistently shows higher temporary storage times for E14 bases, often exceeding the 2.5-day standard, particularly in 2022 and 2023, suggesting potential bottlenecks in its storage processes.

Analysis

1. Production Time: Henderson NV tends to have slightly higher average production times for E14 and E17 bases (around 2.1–2.2 days) compared to Appleton WI and Greenville SC (1.9–2.0 days), especially in 2023. This suggests Henderson may face inefficiencies in producing these products.
2. Temporary Storage Time: Henderson NV frequently exceeds the 2.5-day storage standard for E14 and E12 bases, with averages reaching 3 days in some months. Appleton WI and Greenville SC generally stay below or close to the 2.5-day mark, indicating better storage management.
3. Shipping Time: Henderson NV shows longer shipping times for E17 and E26 bases (up to 7 days in some cases) compared to Appleton WI and Greenville SC, which average 3–4 days. This could indicate logistical challenges at Henderson.
4. Cases Produced: Henderson NV produces significantly more cases across all products (e.g., 7,549 total cases vs. 4,379 for Appleton WI), likely due to higher demand or capacity, but this may contribute to its storage and shipping delays.
5. Cases Shipped: The Henderson NV to Jackson MS combination consistently ships the highest number of cases (2,399 total), while Henderson NV to Sante Fe NM ships the least (1,383). This suggests a demand concentration in Jackson MS.

Conclusion: Henderson NV’s higher production and shipping volumes come with trade-offs in longer storage and shipping times, particularly for E14 and E17 bases. BBB should investigate potential bottlenecks in Henderson’s processes to align with the 2.5-day storage standard and improve shipping efficiency. Appleton WI and Greenville SC demonstrate more consistent performance across metrics, making them models for potential process improvements at Henderson.